COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[4]:

Currently data as of date: 2020-11-10T17:00:00

 

What's in the original dataframe?

Out[5]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note']

Out[6]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... variazione_totale_positivi nuovi_positivi dimessi_guariti deceduti casi_da_sospetto_diagnostico casi_da_screening totale_casi tamponi casi_testati note
5476 2020-11-10T17:00:00 ITA 19 Sicilia 38.115697 13.362357 1348 195 1543 21289 ... 893 1201 9928 735 20749.0 12746.0 33495 770408 535921.0 NaN
5477 2020-11-10T17:00:00 ITA 9 Toscana 43.769231 11.255889 1582 242 1824 44490 ... 1834 2223 19451 1648 54431.0 12982.0 67413 1241973 813816.0 effettuati 33301 tamponi rapidi antigenici di...
5478 2020-11-10T17:00:00 ITA 10 Umbria 43.106758 12.388247 363 66 429 9711 ... 144 485 5392 206 4484.0 11254.0 15738 336098 192401.0 NaN
5479 2020-11-10T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 161 15 176 2123 ... 33 127 1946 218 3936.0 527.0 4463 46630 27907.0 NaN
5480 2020-11-10T17:00:00 ITA 5 Veneto 45.434905 12.338452 1596 204 1800 48450 ... -2912 2763 31362 2643 26311.0 57944.0 84255 2479307 962389.0 Oggi è entrato in produzione il nuovo algoritm...

5 rows × 21 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[7]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives NewPositives Recovered Deaths Diagnostico Screening TotalCases NoOfTests casi_testati note Pop
Date
2020-11-06 2020-11-06 Veneto 45.434905 12.338452 1184 169 1353 42584 43937 3218 3297 25612 2543 25565.0 46527.0 72092 2417660 937280.0 NaN 4905854
2020-11-07 2020-11-07 Veneto 45.434905 12.338452 1300 176 1476 46181 47657 3720 3815 25682 2568 25971.0 49936.0 75907 2437080 944143.0 NaN 4905854
2020-11-08 2020-11-08 Veneto 45.434905 12.338452 1355 185 1540 49430 50970 3313 3362 25725 2574 26082.0 53187.0 79269 2448503 948701.0 NaN 4905854
2020-11-09 2020-11-09 Veneto 45.434905 12.338452 1464 195 1659 51503 53162 2192 2223 25735 2595 26203.0 55289.0 81492 2462529 953936.0 NaN 4905854
2020-11-10 2020-11-10 Veneto 45.434905 12.338452 1596 204 1800 48450 50250 -2912 2763 31362 2643 26311.0 57944.0 84255 2479307 962389.0 Oggi è entrato in produzione il nuovo algoritm... 4905854

 

daily numbers & moving averages (MA)

(double click and click on legend to select one or multiple regions in the graph)

 

All regions together